Sameer Karkhanis
Sameer Karkhanis
Reactions
-
Re: Nested formula with sheet references help
Try this, =MAX(COLLECT({Training Data Range 2 - Date}, {Training Data Range 1 - Name}, Name@row))1 · -
Re: How to Convert Dropdown text into number of days
There is no label value concept in the dropdown so you cannot do that in the same column (Reference), however if you want to populate the next submission date column then you can use the IF formula a…1 · -
Re: COUNTIFS formula with date fields is giving me trouble
Syntactically I see incorrect bracket used after MedschedulerCreated range, should be } instead of ). There is also no need of = sign in the first criteria when comparing the text value as it is assu…1 · -
Re: Can I ignore a row that is missing data and is corrupting my formulas?
@ECD Auto Design Couple of options: In your formula you can do a check if the cell has value using ISBLANK() function and manage your formula logic. You can just wrap the formula within IFERROR(<y…1 · -
Re: Multi-Parameter Color Ball Formula
You need to have the column type set to visual symbols, which you already have. Write a nested IF formula using the conditions you have mentioned and then convert the column to Formula Column (you ca…2 ·
